<?php

/**
* @package   auto_occasion
* @subpackage 
* @author    CMS
* @copyright 2011
* @license    All rights reserved
**/

class annonceCheckSrv {
    /**
    * LIste des enrichissements d'une annonce
    */
    public function check(){
        $cnx    = jDb::getConnection();
        $sql  = " SELECT af.prix FROM ao_formule af ";
        $sql .= " LEFT JOIN ao_lien_formule alf ON af.id=alf.id_formule ";
		$sql .= " LEFT JOIN ao_option_formule aof ON aof.id_option_formule =alf.id_option_formule ";
		$sql .= " AND aof.status='1' ";
        $rs   = $cnx->query($sql);

        $result = array();
        while($row = $rs->fetch()){
			$result[] = $row;
        }

		return $result;
    }



}
